How to: Change the source for a report.
Solution:
In the Report Design view, use the 'Record Source' property box in the property sheet of the report to change the source.
1) If the Database window is not active, activate the Database window.
2) Click the 'Reports' tab in the Database window.
Reports tab
3) Select the desired report from the list box. (The selected report is highlighted.)
4) Click 'Design'. (The selected report appears in the Design view, and the floating Toolbox appears.)
5) Click on the Report Selector.
Report Selector
6) Select the 'View' menu and select 'Properties'. (The property sheet for the report appears.)
7) Click the 'Data' tab.
8) Click on the 'Record Source' box. (A down arrow appears.)
9) Click down arrow. (A drop-down list appears.)
10) Select the new source from the 'Record Source' drop-down list.
11) Select the 'File' menu and select 'Save' to save the report.
